2015F CST8276 QUIZ 1 VERSION A 

1. Which of the following is not a database administration responsibility of a DBA?
	a. managing the database structure
	b. managing performance
	c. managing the DBMS
	d. maintaining backups
	e. all of the above are responsibilities of a DBA (correct)

2. Oracle database certification _____.
	a. guarantees ability to perform a complex job
	b. offers the opportunity to enter into the database administration field
	c. provides additional credentials for a student seeking employment
	d. all of the above
	e. b and c (correct)

3. What would be the most likely reason why a DBA would set up test and production environments?
	a. the DBA may be nervous about transitioning data to production
	b. to reduce the risk of corrupting the production environment (correct)
	c. to test new users in the test environment before they are allowed to access the production environment
	d. there is no reason to have both. Redundancy can lead to errors
	e. data can be distributed to avoid bottlenecks

4. What needs to be considered before installing Oracle on your computer for lab exercises?
	a. hardware requirements (correct)
	b. your SQL skill level
	c. availability of a DBA
	d. concurrency
	e. all of the above

5. Who is the owner of the data dictionary?
	a. system
	b. sysaux
	c. sysman
	d. sys (correct)
	e. DBA

6. Which of the following is the prefix for dynamic performance views?
	a. X$
	b. V$ (correct)
	c. DP$
	d. DPV$
	e. P$

7. The Control_Files initialization parameter holds _____.
	a. the SCN for Oracle's control files
	b. the CKPT for Oracle's control files
	c. one or more names (locations) of Oracle's control files (correct)
	d. the LRU for Oracle's control files
	e. the contents of Oracle's control files

8. The static initialization parameter file called init<sid>.ora is the ____
	a. afile
	b. ifile
	c. iSID
	d. sfFile
	e. pfile (correct)

9. Which of the following commands will show the names and values of Oracle's initialization parameters?
	a. Select name, value from V$DD
	b. Select name, value from V$DataDictionary
	c. Select name, value from V$Database
	d. Select parameter_name, value from V$SYSParm
	e. Select name, value from V$Parameter (correct)

10. The ______ connection mode can help when there are more than one thousand concurrent users by allowing more than one user process to be handled by on server process.
	a. single server
	b. dedicated server
	c. dedicated universal server
	d. connected universal server
	e. shared server (correct)

11. Which of the following best describes the difference between an Oracle instance and a database?
	a. an instance consists of memory structures and processes, whereas a database is composed of physical files (correct)
	b. an instance is used only during database creation; after that, the database is all that is needed
	c. an instance is started whenever the demands on the database are high, but the database is used all the time
	d. an instance is configured using a pfile, whereas a database is configured using an spfile
	e. an instance is persistent once the database is shut down

12. Which of the following Oracle Database structures is a logical subdivision of an Oracle Database instance that is used to group related table, view and other similar objects?
	a. namespace
	b. filespace
	c. tablespace (correct)
	d. a and b
	e. a, b and c

13. Which component of the SGA contains parsed SQL code?
	a. database buffer cache
	b. dictionary cache
	c. library cache (correct)
	d. parse cache
	e. large pool cache

14. ______ are part of the physical files associated with an Oracle database.
	a. Password files
	b. Archived log files
	c. Redo log files (correct)
	d. SPFiles
	e. none of the above

15. A ______ is a physical file containing data, such as indexes and tables.
	a. redo log
	b. data file (correct)
	c. control file
	d. tablespace
	e. segment

16. The primary purpose of redo logs is ______.
	a. Recovery (correct)
	b. Re-doing undo data
	c. Repeating transactions that need to be undone.
	d. Archiving data
	e. None of the above

17. When the last group of redo log files fills, a log switch ______.
	a. Returns to the first group and overwrites it (correct)
	b. Returns to the first group and overwrites it, only if the database is operating in archivelog mode
	c. Returns to the first group and overwrites it, only if the database is operating is not operating in archivelog mode
	d. Returns to the first group, only after the first group has been purged
	e. To a newly created group must occur

18. Redo log files contain changes to data (DML and DDL).
	a. True (correct)
	b. False

19. _____ is an example of the information contained in the control file.
	a. The structure of the database
	b. The database name
	c. The date when the database was created
	d. The pathnames of the datafiles
	e. All of the above (correct)

20. _____ means making redundant copies of files to guarantee that if the original file is damaged, another can take its place immediately. (For example: critical for Control file).
	a. splitting
	b. reproducing
	c. multiplexing (correct)
	d. rolling back
	e. recovering